/*
 Navicat MySQL Data Transfer

 Source Server         : taotaoDB
 Source Server Type    : MySQL
 Source Server Version : 80001
 Source Host           : localhost
 Source Database       : QueryData

 Target Server Type    : MySQL
 Target Server Version : 80001
 File Encoding         : utf-8

 Date: 11/18/2020 21:40:47 PM
*/

SET NAMES utf8mb4;
SET FOREIGN_KEY_CHECKS = 0;

-- ----------------------------
--  Table structure for `casting_distinguish`
-- ----------------------------
DROP TABLE IF EXISTS `casting_distinguish`;
CREATE TABLE `casting_distinguish` (
  `id` int(11) DEFAULT NULL,
  `mark` varchar(255) DEFAULT NULL COMMENT '合金牌号',
  `code` varchar(255) DEFAULT NULL COMMENT '合金代号',
  `casting_method` varchar(255) DEFAULT NULL COMMENT '铸造方法',
  `heat_treatment` varchar(255) DEFAULT NULL COMMENT '热处理状态',
  `tensile_strength` int(11) DEFAULT NULL COMMENT '抗拉强度/MPa',
  `elongation_percentage` int(11) DEFAULT NULL COMMENT '断后伸长率/%',
  `hardness` int(11) DEFAULT NULL COMMENT '硬度HBS'
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

-- ----------------------------
--  Records of `casting_distinguish`
-- ----------------------------
BEGIN;
INSERT INTO `casting_distinguish` VALUES ('1', 'ZAlSi7Cu2Mg', 'ZL118', 'SB', 'T6', '290', '1', '90'), ('2', 'ZAlSi7Cu2Mg', 'ZL118', 'RB', 'T6', '290', '1', '90'), ('3', 'ZAlSi7Cu2Mg', 'ZL118', 'JB', 'T6', '305', '2', '105'), ('4', 'ZAlSi7Mg', 'ZL101', 'S', 'F', '155', '2', '50'), ('5', 'ZAlSi7Mg', 'ZL101', 'R', 'F', '155', '2', '50'), ('6', 'ZAlSi7Mg', 'ZL101', 'J', 'F', '155', '2', '50'), ('7', 'ZAlSi7Mg', 'ZL101', 'K', 'F', '155', '2', '50'), ('8', 'ZAlSi7Mg', 'ZL101', 'S', 'T2', '135', '2', '45'), ('9', 'ZAlSi7Mg', 'ZL101', 'R', 'T2', '135', '2', '45'), ('10', 'ZAlSi7Mg', 'ZL101', 'J', 'T2', '135', '2', '45'), ('11', 'ZAlSi7Mg', 'ZL101', 'K', 'T2', '135', '2', '45'), ('12', 'ZAlSi7Mg', 'ZL101', 'JB', 'T4', '185', '4', '50'), ('13', 'ZAlSi7Mg', 'ZL101', 'S', 'T4', '175', '4', '50'), ('14', 'ZAlSi7Mg', 'ZL101', 'R', 'T4', '175', '4', '50'), ('15', 'ZAlSi7Mg', 'ZL101', 'K', 'T4', '175', '4', '50'), ('16', 'ZAlSi7Mg', 'ZL101', 'JB', 'T5', '205', '2', '60'), ('17', 'ZAlSi7Mg', 'ZL101', 'J', 'T5', '205', '2', '60'), ('18', 'ZAlSi7Mg', 'ZL101', 'S', 'T5', '195', '2', '60'), ('19', 'ZAlSi7Mg', 'ZL101', 'R', 'T5', '195', '2', '60'), ('20', 'ZAlSi7Mg', 'ZL101', 'K', 'T5', '195', '2', '60'), ('21', 'ZAlSi7Mg', 'ZL101', 'SB', 'T5', '195', '2', '60'), ('22', 'ZAlSi7Mg', 'ZL101', 'RB', 'T5', '195', '2', '60'), ('23', 'ZAlSi7Mg', 'ZL101', 'KB', 'T5', '195', '2', '60'), ('24', 'ZAlSi7Mg', 'ZL101', 'SB', 'T6', '225', '1', '70'), ('25', 'ZAlSi7Mg', 'ZL101', 'RB', 'T6', '225', '1', '70'), ('26', 'ZAlSi7Mg', 'ZL101', 'KB', 'T6', '225', '1', '70'), ('27', 'ZAlSi7Mg', 'ZL101', 'SB', 'T7', '195', '2', '60'), ('28', 'ZAlSi7Mg', 'ZL101', 'RB', 'T7', '195', '2', '60'), ('29', 'ZAlSi7Mg', 'ZL101', 'KB', 'T7', '195', '2', '60'), ('30', 'ZAlSi7Mg', 'ZL101', 'SB', 'T8', '155', '3', '55'), ('31', 'ZAlSi7Mg', 'ZL101', 'RB', 'T8', '155', '3', '55'), ('32', 'ZAlSi7Mg', 'ZL101', 'KB', 'T8', '155', '3', '55'), ('33', 'ZAlMgSi7MgA', 'ZL101A', 'S', 'T4', '195', '5', '60'), ('34', 'ZAlMgSi7MgA', 'ZL101A', 'R', 'T4', '195', '5', '60'), ('35', 'ZAlMgSi7MgA', 'ZL101A', 'K', 'T4', '195', '5', '60'), ('36', 'ZAlMgSi7MgA', 'ZL101A', 'J', 'T4', '225', '5', '60'), ('37', 'ZAlMgSi7MgA', 'ZL101A', 'JB', 'T4', '225', '5', '60'), ('38', 'ZAlMgSi7MgA', 'ZL101A', 'S', 'T5', '235', '4', '70'), ('39', 'ZAlMgSi7MgA', 'ZL101A', 'R', 'T5', '235', '4', '70'), ('40', 'ZAlMgSi7MgA', 'ZL101A', 'K', 'T5', '235', '4', '70'), ('41', 'ZAlMgSi7MgA', 'ZL101A', 'SB', 'T5', '235', '4', '70'), ('42', 'ZAlMgSi7MgA', 'ZL101A', 'RB', 'T5', '235', '4', '70'), ('43', 'ZAlMgSi7MgA', 'ZL101A', 'KB', 'T5', '235', '4', '70'), ('44', 'ZAlMgSi7MgA', 'ZL101A', 'J', 'T5', '265', '4', '70'), ('45', 'ZAlMgSi7MgA', 'ZL101A', 'JB', 'T5', '265', '4', '70'), ('46', 'ZAlMgSi7MgA', 'ZL101A', 'SB', 'T6', '275', '2', '80'), ('47', 'ZAlMgSi7MgA', 'ZL101A', 'RB', 'T6', '275', '2', '80'), ('48', 'ZAlMgSi7MgA', 'ZL101A', 'KB', 'T6', '275', '2', '80'), ('49', 'ZAlMgSi7MgA', 'ZL101A', 'J', 'T6', '295', '3', '80'), ('50', 'ZAlMgSi7MgA', 'ZL101A', 'JB', 'T6', '295', '3', '80'), ('51', 'ZAlSi12', 'ZL102', 'SB', 'F', '145', '4', '50'), ('52', 'ZAlSi12', 'ZL102', 'RB', 'F', '145', '4', '50'), ('53', 'ZAlSi12', 'ZL102', 'JB', 'F', '145', '4', '50'), ('54', 'ZAlSi12', 'ZL102', 'KB', 'F', '145', '4', '50'), ('55', 'ZAlSi12', 'ZL102', 'J', 'F', '155', '2', '50'), ('56', 'ZAlSi12', 'ZL102', 'B', 'T2', '135', '4', '50'), ('57', 'ZAlSi12', 'ZL102', 'RB', 'T2', '135', '4', '50'), ('58', 'ZAlSi12', 'ZL102', 'JB', 'T2', '135', '4', '50'), ('59', 'ZAlSi12', 'ZL102', 'KB', 'T2', '135', '4', '50'), ('60', 'ZAlSi12', 'ZL102', 'J', 'T2', '145', '2', '50'), ('61', 'ZAlSi9Mg', 'ZL104', 'S', 'F', '145', '2', '50'), ('62', 'ZAlSi9Mg', 'ZL104', 'J', 'F', '145', '2', '50'), ('63', 'ZAlSi9Mg', 'ZL104', 'R', 'F', '145', '2', '50'), ('64', 'ZAlSi9Mg', 'ZL104', 'K', 'F', '145', '2', '50'), ('65', 'ZAlSi9Mg', 'ZL104', 'J', 'T1', '195', '2', '65'), ('66', 'ZAlSi9Mg', 'ZL104', 'SB', 'T6', '225', '2', '70'), ('67', 'ZAlSi9Mg', 'ZL104', 'RB', 'T6', '225', '2', '70'), ('68', 'ZAlSi9Mg', 'ZL104', 'KB', 'T6', '225', '2', '70'), ('69', 'ZAlSi9Mg', 'ZL104', 'J', 'T6', '235', '2', '70'), ('70', 'ZAlSi9Mg', 'ZL104', 'JB', 'T6', '235', '2', '70'), ('71', 'ZAlSi5Cu1Mg', 'ZL105', 'S', 'T1', '155', '0', '65'), ('72', 'ZAlSi5Cu1Mg', 'ZL105', 'J', 'T1', '155', '0', '65'), ('73', 'ZAlSi5Cu1Mg', 'ZL105', 'R', 'T1', '155', '0', '65'), ('74', 'ZAlSi5Cu1Mg', 'ZL105', 'K', 'T1', '155', '0', '65'), ('75', 'ZAlSi5Cu1Mg', 'ZL105', 'S', 'T5', '195', '1', '70'), ('76', 'ZAlSi5Cu1Mg', 'ZL105', 'R', 'T5', '195', '1', '70'), ('77', 'ZAlSi5Cu1Mg', 'ZL105', 'K', 'T5', '195', '1', '70'), ('78', 'ZAlSi5Cu1Mg', 'ZL105', 'J', 'T5', '235', '0', '70'), ('79', 'ZAlSi5Cu1Mg', 'ZL105', 'S', 'T6', '225', '0', '70'), ('80', 'ZAlSi5Cu1Mg', 'ZL105', 'R', 'T6', '225', '0', '70'), ('81', 'ZAlSi5Cu1Mg', 'ZL105', 'K', 'T6', '225', '0', '70'), ('82', 'ZAlSi5Cu1Mg', 'ZL105', 'S', 'T7', '175', '1', '65'), ('83', 'ZAlSi5Cu1Mg', 'ZL105', 'J', 'T7', '175', '1', '65'), ('84', 'ZAlSi5Cu1Mg', 'ZL105', 'R', 'T7', '175', '1', '65'), ('85', 'ZAlSi5Cu1Mg', 'ZL105', 'K', 'T7', '175', '1', '65'), ('86', 'ZAlSi5Cu1MgA', 'ZL105A', 'SB', 'T5', '275', '1', '80'), ('87', 'ZAlSi5Cu1MgA', 'ZL105A', 'R', 'T5', '275', '1', '80'), ('88', 'ZAlSi5Cu1MgA', 'ZL105A', 'K', 'T5', '275', '1', '80'), ('89', 'ZAlSi5Cu1MgA', 'ZL105A', 'J', 'T5', '295', '2', '80'), ('90', 'ZAlSi5Cu1MgA', 'ZL105A', 'JB', 'T5', '295', '2', '80'), ('91', 'ZAlSi8Cu1Mg', 'ZL106', 'SB', 'F', '175', '1', '70'), ('92', 'ZAlSi8Cu1Mg', 'ZL106', 'JB', 'T1', '195', '2', '70'), ('93', 'ZAlSi8Cu1Mg', 'ZL106', 'SB', 'T5', '235', '2', '60'), ('94', 'ZAlSi8Cu1Mg', 'ZL106', 'JB', 'T5', '235', '2', '70'), ('95', 'ZAlSi8Cu1Mg', 'ZL106', 'SB', 'T6', '245', '1', '80'), ('96', 'ZAlSi8Cu1Mg', 'ZL106', 'JB', 'T6', '265', '2', '70'), ('97', 'ZAlSi8Cu1Mg', 'ZL106', 'SB', 'T7', '225', '2', '60'), ('98', 'ZAlSi8Cu1Mg', 'ZL106', 'J', 'T7', '245', '2', '60'), ('99', 'ZAlSi7Cu4', 'ZL107', 'SB', 'F', '165', '2', '65'), ('100', 'ZAlSi7Cu4', 'ZL107', 'SB', 'T6', '245', '2', '90'), ('101', 'ZAlSi7Cu4', 'ZL107', 'J', 'F', '195', '2', '70'), ('102', 'ZAlSi7Cu4', 'ZL107', 'J', 'T6', '275', '2', '100'), ('103', 'ZAlSi12Cu1Mg', 'ZL108', 'J', 'T1', '195', '0', '85'), ('104', 'ZAlSi12Cu1Mg', 'ZL108', 'J', 'T6', '245', '0', '90'), ('105', 'ZAlSi12Cu1Mg', 'ZL109', 'J', 'T1', '195', '0', '90'), ('106', 'ZAlSi12Cu1Mg', 'ZL109', 'J', 'T6', '245', '0', '100'), ('107', 'ZAlSi5Cu6Mg', 'ZL110', 'S', 'F', '125', '0', '80'), ('108', 'ZAlSi5Cu6Mg', 'ZL110', 'J', 'F', '155', '0', '80'), ('109', 'ZAlSi5Cu6Mg', 'ZL110', 'S', 'T1', '145', '0', '80'), ('110', 'ZAlSi5Cu6Mg', 'ZL110', 'J', 'T1', '165', '0', '90'), ('111', 'ZAlSi19Cu2Mg', 'ZL111', 'J', 'F', '205', '2', '80'), ('112', 'ZAlSi19Cu2Mg', 'ZL111', 'SB', 'T6', '255', '2', '90'), ('113', 'ZAlSi19Cu2Mg', 'ZL111', 'J', 'T6', '315', '2', '100'), ('114', 'ZAlSi19Cu2Mg', 'ZL111', 'JB', 'T6', '315', '2', '100'), ('115', 'ZAlSi7Mg1A', 'ZL114A', 'SB', 'T5', '290', '2', '85'), ('116', 'ZAlSi7Mg1A', 'ZL114A', 'J', 'T5', '310', '3', '90'), ('117', 'ZAlSi7Mg1A', 'ZL114A', 'JB', 'T5', '310', '3', '90'), ('118', 'ZAlSi5Zn1Mg', 'ZL115', 'S', 'T4', '225', '4', '70'), ('119', 'ZAlSi5Zn1Mg', 'ZL115', 'J', 'T4', '275', '6', '80'), ('120', 'ZAlSi5Zn1Mg', 'ZL115', 'S', 'T5', '275', '4', '90'), ('121', 'ZAlSi5Zn1Mg', 'ZL115', 'J', 'T5', '315', '5', '100'), ('122', 'ZAlSi8MgBe', 'ZL116', 'S', 'T4', '255', '4', '70'), ('123', 'ZAlSi8MgBe', 'ZL116', 'J', 'T4', '275', '6', '80'), ('124', 'ZAlSi8MgBe', 'ZL116', 'S', 'T5', '295', '2', '85'), ('125', 'ZAlSi8MgBe', 'ZL116', 'J', 'T5', '335', '4', '90'), ('126', 'ZAlCu5Mn', 'ZL201', 'S', 'T4', '295', '8', '70'), ('127', 'ZAlCu5Mn', 'ZL201', 'J', 'T4', '295', '8', '70'), ('128', 'ZAlCu5Mn', 'ZL201', 'R', 'T4', '295', '8', '70'), ('129', 'ZAlCu5Mn', 'ZL201', 'K', 'T4', '295', '8', '70'), ('130', 'ZAlCu5Mn', 'ZL201', 'S', 'T5', '335', '4', '90'), ('131', 'ZAlCu5Mn', 'ZL201', 'J', 'T5', '335', '4', '90'), ('132', 'ZAlCu5Mn', 'ZL201', 'R', 'T5', '335', '4', '90'), ('133', 'ZAlCu5Mn', 'ZL201', 'K', 'T5', '335', '4', '90'), ('134', 'ZAlCu5Mn', 'ZL201', 'S', 'T7', '315', '2', '80'), ('135', 'ZAlCu5MnA', 'ZL201A', 'S', 'T5', '390', '8', '100'), ('136', 'ZAlCu5MnA', 'ZL201A', 'J', 'T5', '390', '8', '100'), ('137', 'ZAlCu5MnA', 'ZL201A', 'R', 'T5', '390', '8', '100'), ('138', 'ZAlCu5MnA', 'ZL201A', 'K', 'T5', '390', '8', '100'), ('139', 'ZAlCu4', 'ZL203', 'S', 'T4', '195', '6', '60'), ('140', 'ZAlCu4', 'ZL203', 'R', 'T4', '195', '6', '60'), ('141', 'ZAlCu4', 'ZL203', 'K', 'T4', '195', '6', '60'), ('142', 'ZAlCu4', 'ZL203', 'R', 'T4', '195', '6', '60'), ('143', 'ZAlCu4', 'ZL203', 'K', 'T4', '195', '6', '60'), ('144', 'ZAlCu4', 'ZL203', 'J', 'T4', '205', '6', '60'), ('145', 'ZAlCu4', 'ZL203', 'S', 'T5', '215', '3', '70'), ('146', 'ZAlCu4', 'ZL203', 'R', 'T5', '215', '3', '70'), ('147', 'ZAlCu4', 'ZL203', 'K', 'T5', '215', '3', '70'), ('148', 'ZAlCu4', 'ZL203', 'R', 'T5', '215', '3', '70'), ('149', 'ZAlCu4', 'ZL203', 'K', 'T5', '215', '3', '70'), ('150', 'ZAlCu4', 'ZL203', 'J', 'T5', '225', '3', '70'), ('151', 'ZAlCu5MnCdA', 'ZL204A', 'S', 'T5', '440', '4', '100'), ('152', 'ZAlCu5MnCdVA', 'ZL205A', 'S', 'T5', '440', '7', '100'), ('153', 'ZAlCu5MnCdVA', 'ZL205A', 'S', 'T6', '470', '3', '120'), ('154', 'ZAlCu5MnCdVA', 'ZL205A', 'S', 'T7', '460', '2', '110'), ('155', 'ZAlRECu3Si2', 'ZL207', 'S', 'T1', '165', '2', '75'), ('156', 'ZAlRECu3Si2', 'ZL207', 'J', 'T1', '175', '2', '75'), ('157', 'ZAlMg10', 'ZL301', 'S', 'T4', '280', '10', '60'), ('158', 'ZAlMg10', 'ZL301', 'J', 'T4', '280', '10', '60'), ('159', 'ZAlMg10', 'ZL301', 'R', 'T4', '280', '10', '60'), ('160', 'ZAlMg5Si', 'ZL303', 'S', 'F', '145', '1', '55'), ('161', 'ZAlMg5Si', 'ZL303', 'J', 'F', '145', '1', '55'), ('162', 'ZAlMg5Si', 'ZL303', 'R', 'F', '145', '1', '55'), ('163', 'ZAlMg5Si', 'ZL303', 'K', 'F', '145', '1', '55'), ('164', 'ZAlMg8Zn1', 'ZL305', 'S', 'T4', '290', '8', '90'), ('165', 'ZAlZn11Si7', 'ZL401', 'S', 'T1', '290', '2', '80'), ('166', 'ZAlZn11Si7', 'ZL401', 'R', 'T1', '290', '2', '80'), ('167', 'ZAlZn11Si7', 'ZL401', 'J', 'T1', '290', '2', '80'), ('168', 'ZAlZn11Si7', 'ZL401', 'J', 'T1', '245', '2', '90'), ('169', 'ZAlZn6Mg', 'ZL402', 'J', 'T1', '235', '4', '70'), ('170', 'ZAlZn6Mg', 'ZL402', 'S', 'T1', '215', '4', '65');
COMMIT;

-- ----------------------------
--  Table structure for `casting_information`
-- ----------------------------
DROP TABLE IF EXISTS `casting_information`;
CREATE TABLE `casting_information` (
  `id` int(11) NOT NULL,
  `index` int(11) DEFAULT NULL COMMENT '编号',
  `name` varchar(255) DEFAULT NULL COMMENT '名称',
  `chemical_component` varchar(255) DEFAULT NULL COMMENT '化学成分',
  `cutline` varchar(255) DEFAULT NULL COMMENT '简单说明',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

-- ----------------------------
--  Records of `casting_information`
-- ----------------------------
BEGIN;
INSERT INTO `casting_information` VALUES ('1', '0', 'ZL105A', 'Si: 4.5-5.5\nCu: 1.0-1.5\nMg: 0.4-0.55\nFe:<0.2\nMn:<0.1', 'GB：ZAlSi5Cu1MgA\nASTM ： A355\nISO：Al-Si5Cu1Mg'), ('2', '1', 'ZAlSi05', '', '含0.5% Si的精练铝'), ('3', '2', 'ZL104', 'Si: 8.0-10.5 \nMg: 0.17-0.35 \nMn :0.2-0.5\nFe:<0.6\nCu:<0.1\nZn:<0.25\nBe:<0.1', 'GB： ZAlSi9Mg \nISO： Al-Si10Mg\nJIS:AC4A\nEN: AlSi9Mg\nDIN:AlSi9Mg\nASTM:360.0\n用途：机匣、框架、缸体等'), ('4', '3', 'ZL102', 'Si 10.0-13.0 Fe:<0.7 Cu:<0.3 Mg:<0.6 Zn:<0.1   Mn:<0.5  Ti:<0.2', 'ISO:Al-Si12\nGB:ZAlSi12\nJIS:AC3A \nEN:AlSi12(b)\nASTM:413.0  B413.0\n用途：仪表壳体、活塞、制动器外壳等'), ('5', '4', 'ZL108', 'Si 11.0-13.0  Cu 1.0-2.0  Mg 0.4-1.0  Mn 0.3-0.9 Zn:<0.2 Ti:<0.2   Ni:<0.3', 'ASTM:  B332.0\nGB: ZAlSi12Cu2Mg1'), ('6', '5', 'ZL109', 'Si 11.0-13.0  Cu 0.5-1.5  Mg 0.8-1.3  Ni 0.8-1.5 Zn:<0.2  Mn:<0.2   Ti:<0.2', 'GB:  ZAlSi12CuNiMg\nJIS:AC8A \nEN: AlSi12CuNiMg \nASTM:A332.0\n用途：发动机活塞等'), ('7', '6', 'ZL702', '', '军标'), ('8', '7', 'ZL101', 'Si 6.5-7.5   Mg 0.25-0.45 Fe:<0.5  Cu:<0.2   Zn:<0.3 Be:<0.1', 'JIS: AC4C\nGB:  ZAlSi7Mg \nISO: Al-Si7Mg(Fe)\nEN: AlSi7Mg0.3 \nASTM:356.0\n用途：支臂、支架、复件壳体、仪器外壳等'), ('9', '8', 'C19Mn5', 'Si 6.5-7.5  Mg 0.45-0.75  Ti 0.10-0.20 Be 0.04-0.07 Fe:<0.2  Mn:<0.1   Zn:<0.1 Ti:<0.1', 'GB: ZAlSi7Mg1A \nEN: AlSi7Mg0.3 \nASTM:A357.0  D357.0'), ('10', '9', 'ZAlSi9Cu3', '', '德国标准牌号:  3.2163'), ('11', '10', 'ZL402', 'Zn 5.0-6.5  Mg 0.5-0.65  Ti 0.15-0.25  Cr 0.4-0.6', 'GB/T1173-2013  ZAlZn6Mg\n用途：高空飞行氧气调节器'), ('12', '11', 'C19Mn5', '', ''), ('13', '12', 'ZL105', 'Si 4.5-5.5  Cu 1.0-1.5  Mg 0.4-0.6\nFe：<0.6     Zn：<0.3     Mn：<0.5     Be：<0.1', 'GB：ZAlSi5Cu1Mg\nEN ： AlSi5Cu1Mg\nASTM ： A355\nJIS：  AC4D\nISO：Al-Si5Cu1Mg\nDIN：AlSi5\n用途：气缸、机匣、油泵壳体等'), ('14', '13', 'ZL116', 'Si 6.5-8.5  Mg 0.35-0.55  Ti 0.10-0.30 Be 0.15-0.40 Fe：<0.6     Cu：<0.3      Zn：<0.3     Mn：<0.1     Zr：<0.2', 'GB:  ZAlSi8MgBe \nASTM:B358.0'), ('15', '14', 'ZL101A', 'Si 6.5-7.5  Mg 0.25-0.45 Ti 0.08-0.20', '德国标准牌号:  3.237\nGB/T 1173-2013  ZAlSi7MgA \n美国标准 A356.0\n用途：机匣、泵体、壳体等'), ('16', '15', 'ZL401', 'Si 6.0-8.0  Zn 9.0-13.0  Mg 0.1-0.3', '用途：仪表薄壳体等'), ('17', '16', 'ZL106', 'Si 7.5-8.5  Cu 1.0-1.5  Mg 0.3-0.5  Mn 0.3-0.5  Ti 0.10-0.25 Fe:<0.6     Zn:<0.2', 'GB: ZAlSi8Cu1Mg \nDIN: AlSi8Cu3\nASTM: 328.0'), ('18', '17', 'ZL107', 'Si 6.5-7.5  Cu 3.5-4.5    Fe:<0.5     Zn:<0.3 Mg:<0.1     Mn:<0.5', 'GB: ZAlSi7Cu4 \nISO:Al-Si6Cu4\nJIS: AC2B \nEN: AlSi6Cu4 \nASTM: 319.0'), ('19', '18', 'ZL110', 'Si 4.0-6.0  Cu 5.0-8.0  Mg 0.2-0.5    Zn:<0.6 Mn:<0.5', 'GB: ZAlSi5Cu6Mg'), ('20', '19', 'ZL111', 'Si 8.0-10.0  Cu 1.3-1.8  Mg 0.4-0.6  Mn 0.10-0.35 Ti 0.10-0.35 Fe:<0.4     Zn:<0.1', 'GB: ZAlSi9Cu2Mg\nEN: AlSi8Cu3\nASTM: 354.0'), ('21', '20', 'ZL115', 'Si 4。8-6.2  Mg 0.4-0.65  Zn 1.2-1.8  Sb 0.1-0.25 Fe:<0.3     Cu:<0.1     Mn:<0.5', 'GB: ZAlSi5Zn1Mg'), ('22', '21', 'ZL118', 'Si 6.0-8.0  Cu 1.3-1.8  Mg 0.2-0.5  Mn 0.1-0.3  Ti 0.10-0.25', 'GB: ZAlSi7Cu2Mg'), ('23', '22', 'ZL201', 'Cu 4.5-5.3    Mn 0.6-1.0    Ti 0.15-0.35  Fe:<=0.25     Si:<=0.3      Mg:<=0.05     Zn:<=0.2', 'GB: ZAlCu5Mn\n用途：外挂架、支臂等'), ('24', '23', 'ZL201A', 'Cu 4.8-5.3    Mn 0.6-1.0    Ti 0.15-0.35  Fe:<=0.15  Si:<=0.1      Mg:<=0.05     Zn:<=0.1      Zr:<=0.15', 'GB: ZAlCu5MnA\n用途：梁、框、肋、轮毂等'), ('25', '24', 'ZL203', 'Cu 4.0-5.0    Fe:<=0.8      Si:<=1.2      Mg:<=0.05     Zn:<=0.25     Mn;<=0.1      Ti:<=0.2      Zr:<=0.1', 'GB: ZAlCu4\n用途：曲轴箱、支架、飞轮盖等'), ('26', '25', 'ZL204A', 'Cu 4.6-5.3    Mn 0.6-0.9    Ti 0.15-0.35  Cd 0.15-0.25  Fe:<=0.15     Si:<=0.06     Mg:<=0.05     Zn:<=0.1      Zr:<=0.15', 'GB: ZAlCu5MnCdA\n用途：梁、框等'), ('27', '26', 'ZL205A', 'Cu 4.6-5.3    Mn 0.3-0.5    Ti 0.15-0.35  Cd 0.15-0.25  V 0.05-0.30   Zr 0.05-0.20  Fe:<=0.15     Si:<=0.06     Mg:<=0.05     Zn:<=0.1      Zr:<=0.15', 'GB: ZAlCu5MnCdVA\n用途：梁、框、支臂、支座等'), ('28', '27', 'ZL207', 'Si 1.6-2.0    Cu 3.0-4.0    Mg:0.15-0.25  Mn 0.9-1.2    Ni 0.2-0.3    Zr 0.15-0.25  RE 4.0-5.0    Fe:<=0.6      Zn:<=0.2', 'GB: ZAlRECu3Si2\n用途：飞机空气分配器、电动活门壳体等'), ('29', '28', 'ZL301', 'Mg 9.5-11.0   Fe:<=0.3      Si:<=0.3      Cu:<=0.1      Zn:<=0.15     Mn:<=0.15     Ti:<=0.15     Zr:<=0.2', 'GB: ZAlMg10\n用途：耐蚀性高的飞行器零件'), ('30', '29', 'ZL303', 'Si 0.8-1.3    Mg 4.5-5.5    Mn 0.1-0.4    Fe:<=0.5      Cu:<=0.1      Zn:<=0.2      Ti:<=0.2', 'GB: ZAlMg5Si'), ('31', '30', 'ZL305', 'Cu (Zn)1.0-1.5\nMg 7.5-9.0    Ti 0.1-0.2    Fe:<=0.3      Si:<=0.2      Cu:<=0.1      Mn:<=0.1', 'GB: ZAlMg8Zn1'), ('32', '31', 'ZM1', 'Zn 3.5-5.5    Zr 0.5-1.0    Cu:<=0.1      Ni:<=0.01', 'GB: ZMgZn5Zr'), ('33', '32', 'ZM2', 'Zn 3.5-5.0    Zr 0.5-1.0 \nRE 0.75-1.75  Cu:<=0.1     Ni:<=0.01', 'GB: ZMgZn4Re1Zr'), ('34', '33', 'ZM3', 'Zn 0.2-0.7    Zr 0.4-1.0 \nRE 2.5-4.0  Cu:<=0.1      Ni:<=0.01', 'GB: ZMgRE3ZnZr'), ('35', '34', 'ZM4', 'Zn 2.0-3.0    Zr 0.5-1.0 \nRE 2.5-4.0  Cu:<=0.1      Ni:<=0.01', 'GB: ZMgRE3Zn2Zr'), ('36', '35', 'ZM5', 'Zn 0.2-0.8    Al 7.5-9.0 \nMn 0.15-0.50\nSi:<=0.3  Cu:<=0.2\nFe:<=0.05     Ni:<=0.01', 'GB: ZMgAl8Zn'), ('37', '36', 'ZM6', 'Zn 0.2-0.7    Zr 0.4-1.0 \nRE 2.0-2.8 Cu:<=0.1      Ni:<=0.01', 'GB: ZMgRE2ZnZr'), ('38', '37', 'ZM7', 'Zn 7.5-9.0    Zr 0.5-1.0 \nAg 0.6-1.2  Cu:<=0.1      Ni:<=0.01', 'GB: ZMgZn8AgZr'), ('39', '38', 'ZM10', 'Zn 0.6-1.2    Al 9.0-10.2 \nMn 0.1-0.5 \nSi:<=0.3  Cu:<=0.2\nFe:<=0.05     Ni:<=0.01', 'GB: ZMgAl10Zn'), ('40', '39', 'ZTA1', 'Fe:<=0.25\nSi:<=0.1\nC:<=0.1\nN:<=0.03\nH:<=0.015\nO:<=0.25', 'GB: ZTi1'), ('41', '40', 'ZTA2', 'Fe:<=0.3\nSi:<=0.15\nC:<=0.1\nN:<=0.05\nH:<=0.015\nO:<=0.35', 'GB: ZTi2'), ('42', '41', 'ZTA3', 'Fe:<=0.4\nSi:<=0.15\nC:<=0.1\nN:<=0.05\nH:<=0.015\nO:<=0.04', 'GB: ZTi3'), ('43', '42', 'ZTA5', 'Al 3.3-4.7\nFe:<=0.3\nSi:<=0.15\nC:<=0.1\nN:<=0.04\nH:<=0.015\nO:<=0.2', 'GB: ZTiAl4'), ('44', '43', 'ZTA7', 'Al 4.0-6.0\nSn 2.0-3.0\nFe:<=0.5\nSi:<=0.15\nC:<=0.1\nN:<=0.05\nH:<=0.015\nO:<=0.2', 'GB: ZTiAl5Sn2.5'), ('45', '44', 'ZTB32', 'Mo 30-40 \nFe:<=0.3\nSi:<=0.15\nC:<=0.1\nN:<=0.05\nH:<=0.015\nO:<=0.15', 'GB: ZTiMo32'), ('46', '45', 'ZTC4', 'Al 5.5-6.8\nV 3.5-4.5\nFe:<=0.4\nSi:<=0.15\nC:<=0.1\nN:<=0.05\nH:<=0.015\nO:<=0.25', 'GB: ZTiAl6V4'), ('47', '46', 'ZTC21', 'Al 5.5-6.5\nSn 4.0-5.0\nMo 1.0-2.0\nNb 1.5-2.5\nFe:<=0.3\nSi:<=0.15\nC:<=0.1\nN:<=0.05\nH:<=0.015\nO:<=0.2', 'GB: ZTiAl6Sn4.5Nb2Mo1.5'), ('48', '47', 'QT400-18', '无', '主要金相组织：铁素体'), ('49', '48', 'QT400-15', '无', '主要金相组织：铁素体'), ('50', '49', 'QT450-10', '无', '主要金相组织：铁素体'), ('51', '50', 'QT500-7', '无', '主要金相组织：铁素体+珠光体'), ('52', '51', 'QT600-3', '无', '主要金相组织：珠光体+铁素体'), ('53', '52', 'QT700-2', '无', '主要金相组织：珠光体'), ('54', '53', 'QT800-2', '无', '主要金相组织：珠光体或回火组织'), ('55', '54', 'QT900-2', '无', '主要金相组织：贝氏体或回火马氏体'), ('56', '55', 'ZG20Mn', 'C:0.16-0.22\nSi:0.6-0.8\nMn:1.0-1.3\nS:0.03\nP:0.03\nNi:0.4', '无'), ('57', '56', 'ZG30Mn', 'C:0.27-0.34\nSi:0.3-0.5\nMn:1.2-1.5\nS:0.03\nP:0.03', '无'), ('58', '57', 'ZG35Mn', 'C:0.3-0.4\nSi:0.6-0.8\nMn:1.1-1.4\nS:0.03\nP:0.03', '无'), ('59', '58', 'ZG40Mn', 'C:0.35-0.45\nSi:0.3-0.45\nMn:1.2-1.5\nS:0.03\nP:0.03', '无'), ('60', '59', 'ZG40Mn2', 'C:0.35-0.45\nSi:0.2-0.4\nMn:1.6-1.8\nS:0.03\nP:0.03', '无'), ('61', '60', 'ZG20CrMo', 'C:0.17-0.25\nSi:0.2-0.45\nMn:0.5-0.8\nS:0.03\nP:0.03\nCr:0.5-0.8\nMo:0.4-0.6', '无'), ('62', '61', 'ZG200-400', 'C<=0.2\nSi<=0.5\nMn<=0.8\nP<=0.04\nS<=0.04', '无'), ('63', '62', 'ZG230-450', 'C<=0.3\nSi<=0.5\nMn<=0.9\nP<=0.04\nS<=0.04', '无'), ('64', '63', 'ZG270-500', 'C 0.35-0.45\nC<=0.4\nSi<=0.5\nMn<=0.9\nP<=0.04\nS<=0.04', '无'), ('65', '64', 'ZG310-570', 'C<=0.5\nSi<=0.6\nMn<=0.9\nP<=0.04\nS<=0.04', '无'), ('66', '65', 'ZG340-640', 'C<=0.6\nSi<=0.6\nMn<=0.9\nP<=0.04\nS<=0.04', '无');
COMMIT;

-- ----------------------------
--  Table structure for `general_para`
-- ----------------------------
DROP TABLE IF EXISTS `general_para`;
CREATE TABLE `general_para` (
  `id` int(11) DEFAULT NULL,
  `name` varchar(255) DEFAULT NULL COMMENT '材料名称',
  `type` varchar(255) DEFAULT NULL COMMENT '类型',
  `ts` varchar(255) DEFAULT NULL COMMENT '固相温度',
  `tl` varchar(255) DEFAULT NULL COMMENT '液相温度',
  `tp` varchar(255) DEFAULT NULL COMMENT '浇筑温度',
  `latent_heat` float DEFAULT NULL COMMENT '潜热',
  `remark` varchar(255) DEFAULT NULL COMMENT '描述',
  `thermischer` float DEFAULT NULL COMMENT '热效率'
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

-- ----------------------------
--  Records of `general_para`
-- ----------------------------
BEGIN;
INSERT INTO `general_para` VALUES ('1', 'AIR', '其他', '10.00', '100.00', '40.00', '2.62', '无', '0'), ('2', '刚玉', '其他', '1,999.00', '1,999.00', '20.00', '0', '无', '0'), ('3', 'ZL203', '铝', '530.00', '650.00', '720.00', '381.64', 'Long Freezing Range', '30'), ('4', 'ZAlSi05', '铝', '638.00', '659.00', '720.00', '394.11', 'Short Freezing Range', '30'), ('5', 'ZL104', '铝', '555.00', '595.00', '680.00', '514.27', 'Short Freezing Range', '30'), ('6', 'ZL102', '铝', '577.00', '600.00', '650.00', '534.18', 'Short Freezing Range', '30'), ('7', 'ZL108', '铝', '529.00', '570.00', '700.00', '513.47', 'Short Freezing Range', '30'), ('8', 'ZAlSi12Cu3Ni2Mg', '铝', '498.00', '571.00', '700.00', '490.6', 'Short Freezing Range', '30'), ('9', 'ZL109', '铝', '538.00', '566.00', '700.00', '509', 'Short Freezing Range', '30'), ('10', 'ZAlSi17Cu3_P', '铝', '492.00', '636.00', '710.00', '401.53', 'Long Freezing Range', '30'), ('11', 'ZAlSi6Cu4', '铝', '482.00', '610.00', '700.00', '415', 'Long Freezing Range', '30'), ('12', 'ZL101', '铝', '542.00', '613.00', '700.00', '430.52', 'Short Freezing Range', '30'), ('13', 'ZL114A', '铝', '534.00', '610.00', '700.00', '436.76', 'Long Freezing Range', '50'), ('14', 'ZAlSi9Cu3', '铝', '520.00', '580.00', '670.00', '479.23', 'Long Freezing Range', '30'), ('15', 'ZL402', '铝', '470.00', '630.00', '700.00', '367.07', 'Long Freezing Range', '30'), ('16', '冷芯盒', '砂', '1,999.00', '1,999.00', '20.00', '0', '无', '0'), ('17', '冷却介质', '其他', '1,000.00', '1,000.00', '30.00', '0', '无', '0'), ('18', '铬砂', '砂', '1,999.90', '1,999.90', '20.00', '0', '无', '0'), ('19', '干铬砂', '砂', '1,999.90', '1,999.90', '20.00', '0', '无', '0'), ('20', 'Ck25', '钢　', '1,425.00', '1,502.00', '1,600.00', '299.16', 'Short Freezing Range', '50'), ('21', 'CuCoBe', '其他', '1,000.00', '1,005.00', '25.00', '223.15', 'Short Freezing Range', '50'), ('22', 'EXTBOUNDARY', '其他', '1,000.00', '1,000.00', '20.00', '0', '无', '0'), ('23', '呋喃树脂砂', '砂', '1,999.00', '1,999.00', '20.00', '0', '无', '0'), ('24', '湿型砂', '砂', '1,999.00', '1,999.00', '20.00', '0', '无', '0'), ('25', 'Glas', '其他', '1,200.00', '1,200.00', '850.00', '0', '无', '0'), ('26', 'Graphit', '其他', '1,999.00', '1,999.00', '20.00', '0', '无', '0'), ('27', 'HEATMED', '其他', '1,000.00', '1,000.00', '170.00', '0', '无', '0'), ('28', 'HS21', 'NF Cobalt', '1,275.00', '1,350.00', '1,480.00', '404.99', 'Short Freezing Range', '50'), ('29', '油砂', '砂', '1,999.00', '1,999.00', '20.00', '0', '无', '0'), ('30', 'PbSb1_8', '其他', '288.00', '315.00', '370.00', '23.1', 'Short Freezing Range', '50'), ('31', '壳型砂', '砂', '1,999.00', '1,999.00', '20.00', '0', '无', '0'), ('32', '干硅砂', '砂', '1,999.90', '1,999.90', '20.00', '0', '无', '0'), ('33', 'STEEL', '钢', '1,448.00', '1,526.00', '1,620.00', '260.5', 'Short Freezing Range', '30'), ('34', 'SiC', '其他', '1,999.00', '1,999.00', '70.00', '0', '无', '0'), ('35', 'Sleeve', '其他', '1,999.00', '1,999.00', '20.00', '0', '无', '0'), ('36', 'Sn', '其他', '231.00', '233.00', '300.00', '46.38', '无', '0'), ('37', 'Water', '其他', '0.00', '0.00', '20.00', '0', '无', '0'), ('38', 'ZAMAG5', 'NF Zinc', '380.00', '386.00', '420.00', '119.83', 'Short Freezing Range', '50'), ('39', '锆砂', '砂', '1,999.90', '1,999.90', '20.00', '0', '无', '0'), ('40', '干锆砂', '砂', '1,999.90', '1,999.90', '20.00', '0', '无', '0'), ('41', '树脂砂', '砂', '1,999.90', '1,999.90', '20.00', '0', '无', '0'), ('42', '水玻璃砂', '砂', '1,999.90', '1,999.90', '20.00', '0', '无', '0'), ('43', '石英干砂', '砂', '1,999.90', '1,999.90', '20.00', '0', '无', '0'), ('44', '石英湿砂', '砂', '1,999.90', '1,999.90', '20.00', '0', '无', '0'), ('45', '铬铁矿砂', '砂', '1,999.90', '1,999.90', '20.00', '0', '无', '0'), ('46', '黄砂', '砂', '1,999.90', '1,999.90', '20.00', '0', '无', '0'), ('47', 'ZL205A', '铝', '544.00', '633.00', '680.00', '370.5', 'Short Freezing Range', '30'), ('48', 'ZL105', '铝', '546.00', '621.00', '670.00', '500.5', 'Short Freezing Range', '30'), ('49', 'ZL116', '铝', '557.00', '596.00', '620.00', '430.5', 'Short Freezing Range', '30'), ('50', 'ZL201', '铝', '548.00', '645.00', '680.00', '395.5', 'Short Freezing Range', '30'), ('51', 'Al203', '其他', '1,999.00', '1,999.00', '20.00', '0', '无', '0'), ('52', 'ZL101A', '铝', '542.00', '613.00', '700.00', '430.52', 'Short Freezing Range', '30'), ('53', '甘奇卡砂', '砂', '1,999.90', '1,999.90', '20.00', '0', '无', '0'), ('54', '红砂', '砂', '1,999.00', '1,999.00', '20.00', '0', '无', '0');
COMMIT;

-- ----------------------------
--  Table structure for `materials`
-- ----------------------------
DROP TABLE IF EXISTS `materials`;
CREATE TABLE `materials` (
  `id` int(11) NOT NULL,
  `name` varchar(255) DEFAULT NULL COMMENT '材料名称',
  `type` varchar(255) DEFAULT NULL COMMENT '材料类型',
  `tensile_strength` int(11) DEFAULT NULL COMMENT '抗拉强度',
  `yield_strength` int(11) DEFAULT NULL COMMENT '屈服强度',
  `elongation_percentage` int(11) DEFAULT NULL COMMENT '断后伸长比例',
  `impact_toughness` int(11) DEFAULT NULL COMMENT '冲击韧性/J',
  `elasticity_modulus` int(11) DEFAULT NULL COMMENT '弹性模量',
  `internal_friction` int(11) DEFAULT NULL COMMENT '内耗',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

-- ----------------------------
--  Records of `materials`
-- ----------------------------
BEGIN;
INSERT INTO `materials` VALUES ('0', 'ZL105A', '铝', '275', '0', '1', '0', '0', '0'), ('2', 'ZL104', '铝', '195', '0', '2', '0', '0', '0'), ('3', 'ZL102', '铝', '145', '0', '4', '0', '0', '0'), ('4', 'ZL108', '铝', '195', '0', '0', '0', '0', '0'), ('6', 'ZL109', '铝', '195', '0', '0', '0', '0', '0'), ('7', 'ZL702', '铝', '0', '0', '0', '0', '0', '0'), ('8', 'ZL101', '铝', '155', '0', '2', '0', '0', '0'), ('9', 'ZL114A', '铝', '290', '0', '2', '0', '0', '0'), ('11', 'ZL402', '铝', '235', '0', '4', '0', '0', '0'), ('12', 'ZL105', '铝', '155', '0', '0', '0', '0', '0'), ('13', 'ZL116', '铝', '255', '0', '4', '0', '0', '0'), ('14', 'ZL101A', '铝', '155', '0', '2', '0', '0', '0'), ('15', 'ZL401', '铝', '195', '0', '2', '0', '0', '0'), ('16', 'ZL106', '铝', '175', '0', '1', '0', '0', '0'), ('17', 'ZL107', '铝', '165', '0', '2', '0', '0', '0'), ('18', 'ZL110', '铝', '125', '0', '3', '0', '0', '0'), ('19', 'ZL111', '铝', '205', '0', '2', '0', '0', '0'), ('20', 'ZL115', '铝', '225', '0', '4', '0', '0', '0'), ('21', 'ZL118', '铝', '290', '0', '1', '0', '0', '0'), ('22', 'ZL201', '铝', '335', '0', '4', '0', '0', '0'), ('23', 'ZL201A', '铝', '390', '0', '8', '0', '0', '0'), ('24', 'ZL203', '铝', '215', '0', '3', '0', '0', '0'), ('25', 'ZL204A', '铝', '440', '0', '4', '0', '0', '0'), ('26', 'ZL205A', '铝', '440', '0', '7', '0', '0', '0'), ('27', 'ZL207', '铝', '0', '0', '0', '0', '0', '0'), ('28', 'ZL301', '铝', '280', '0', '9', '0', '0', '0'), ('29', 'ZL303', '铝', '0', '0', '0', '0', '0', '0'), ('30', 'ZL305', '铝', '290', '0', '8', '0', '0', '0'), ('31', 'ZM1', '镁', '0', '0', '0', '0', '0', '0'), ('32', 'ZM2', '镁', '165', '100', '0', '0', '0', '0'), ('33', 'ZM3', '镁', '105', '0', '0', '0', '0', '0'), ('34', 'ZM4', '镁', '120', '90', '0', '0', '0', '0'), ('35', 'ZM5', '镁', '175', '70', '0', '0', '0', '0'), ('36', 'ZM6', '镁', '180', '120', '0', '0', '0', '0'), ('37', 'ZM7', '镁', '220', '110', '0', '0', '0', '0'), ('38', 'ZM10', '镁', '180', '70', '0', '0', '0', '0'), ('39', 'ZTA1', '钛', '345', '275', '20', '0', '0', '0'), ('40', 'ZTA2', '钛', '440', '370', '13', '0', '0', '0'), ('41', 'ZTA3', '钛', '540', '470', '12', '0', '0', '0'), ('42', 'ZTA5', '钛', '590', '490', '10', '0', '0', '0'), ('43', 'ZTA7', '钛', '795', '725', '8', '0', '0', '0'), ('44', 'ZTB32', '钛', '795', '0', '2', '0', '0', '0'), ('45', 'ZTC4', '钛', '895', '825', '6', '0', '0', '0'), ('46', 'ZTC21', '钛', '980', '850', '5', '0', '0', '0'), ('47', 'QT400-18', '铁', '400', '250', '18', '0', '0', '0'), ('48', 'QT400-15', '铁', '400', '250', '15', '0', '0', '0'), ('49', 'QT450-10', '铁', '450', '310', '10', '0', '0', '0'), ('50', 'QT500-7', '铁', '500', '320', '7', '0', '0', '0'), ('51', 'QT600-3', '铁', '600', '370', '3', '0', '0', '0'), ('52', 'QT700-2', '铁', '700', '420', '2', '0', '0', '0'), ('53', 'QT800-2', '铁', '800', '480', '2', '0', '0', '0'), ('54', 'QT900-2', '铁', '900', '600', '2', '0', '0', '0'), ('55', 'ZG310-570', '钢', '570', '310', '15', '15', '0', '0'), ('56', 'ZG340-640', '钢', '640', '340', '10', '10', '0', '0'), ('57', 'ZG230-450', '钢', '450', '230', '22', '25', '0', '0'), ('58', 'ZG270-500', '钢', '500', '270', '18', '22', '0', '0'), ('59', 'ZG30Mn', '钢', '558', '300', '18', '0', '0', '0'), ('60', 'ZG35Mn', '钢', '570', '345', '12', '24', '0', '0'), ('61', 'ZG40Mn', '钢', '640', '295', '12', '0', '0', '0'), ('62', 'ZG200-400', '钢', '400', '200', '25', '30', '0', '0'), ('63', 'ZG20Mn', '钢', '495', '285', '18', '39', '0', '0'), ('64', 'ZG40Mn2', '钢', '590', '395', '20', '30', '0', '0'), ('65', 'ZG20CrMo', '钢', '460', '245', '18', '30', '0', '0');
COMMIT;

-- ----------------------------
--  Table structure for `user`
-- ----------------------------
DROP TABLE IF EXISTS `user`;
CREATE TABLE `user` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `userName` varchar(255) DEFAULT NULL,
  `password` varchar(255) DEFAULT NULL,
  `type` int(11) DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=utf8;

-- ----------------------------
--  Records of `user`
-- ----------------------------
BEGIN;
INSERT INTO `user` VALUES ('1', 'zhangsan', '123', '1');
COMMIT;

SET FOREIGN_KEY_CHECKS = 1;
